﻿CREATE TABLE [dbo].[SpecBoatData_Tbl] (
    [SpecBoatDataID]  INT            IDENTITY (1, 1) NOT NULL,
    [SpecBoatID]      INT            NULL,
    [Dsc]             NTEXT          NULL,
    [I]               INT            NULL,
    [J]               INT            NULL,
    [P]               INT            NULL,
    [E]               INT            NULL,
    [Isp]             INT            NULL,
    [Spl]             INT            NULL,
    [Py]              INT            NULL,
    [Ey]              INT            NULL,
    [Igs]             INT            NULL,
    [Jgs]             INT            NULL,
    [Iss]             INT            NULL,
    [Jss]             INT            NULL,
    [Ios]             INT            NULL,
    [Jos]             INT            NULL,
    [Iys]             INT            NULL,
    [Jys]             INT            NULL,
    [Draft]           INT            NULL,
    [Cb]              NVARCHAR (255) NULL,
    [Prop]            NVARCHAR (255) NULL,
    [Beam]            INT            NULL,
    [Displ]           INT            NULL,
    [Lwl]             INT            NULL,
    [Upsd]            INT            NULL,
    [Dwsd]            INT            NULL,
    [Dl]              INT            NULL,
    [BowShear]        INT            NULL,
    [BowRake]         INT            NULL,
    [TranShear]       INT            NULL,
    [Loa]             INT            NULL,
    [Designyear]      INT            NULL,
    [MeasurementForm] BIT            NULL,
    [BoatTypeID]      INT            NULL,
    [LastUpdated]     NVARCHAR (50)  NULL,
    [DesignFile]      NVARCHAR (50)  NULL
);

